java UnitilsException: Executed scripts table "PUBLIC"."DBMAINTAIN_SCRIPTS" doesn't exist yet or is invalid [closed]

Posted by Philippe on Programmers See other posts from Programmers or by Philippe
Published on 2012-08-27T04:40:16Z Indexed on 2012/08/29 3:50 UTC
Read the original article Hit count: 399

Filed under:

I want use Unitils for testing my JAVA program, i have following error message "UnitilsException: Executed scripts table "PUBLIC"."DBMAINTAIN_SCRIPTS" doesn't exist yet or is invalid"

My table is into an DDL file, and table is not created

Could you says me if dataSetStructureGenerator.xsd.dirName=src/test/resources/dataset-schema properties is still active in unitils 3.3 ?

My EMPLOYEE table is not created and DBMAINTAIN_SCRIPTS not created too Where is my mistake ?

My DDL file

SET REFERENTIAL_INTEGRITY FALSE;
SET DATABASE COLLATION "French";
SET SCHEMA PUBLIC;
CREATE TABLE DBMAINTAIN_SCRIPTS (FILE_NAME VARCHAR2(150), FILE_LAST_MODIFIED_AT INTEGER, CHECKSUM VARCHAR2(50), EXECUTED_AT VARCHAR2(20), SUCCEEDED INTEGER);
CREATE TABLE EMPLOYEES(ID IDENTITY NOT NULL,NAME VARCHAR(20),TITLE VARCHAR(20),SALARY DOUBLE,NI INTEGER NOT NULL) 

My unitils properties file

# comments documenting these unitils configuration properties removed for
# brevity. look for commenting in unitils-default.properties in the root of the
# unitils jar if needed.

unitils.modules=database,dbunit,easymock,inject

unitils.module.hibernate.enabled=false
unitils.module.spring.enabled=false

# these placeholders are set in avaje.properties
#gere la configuration DBUNIT
database.driverClassName=org.hsqldb.jdbcDriver
database.url=jdbc:hsqldb:mem:unitils-example
database.schemaNames=PUBLIC
database.userName=SA
database.password=
database.dialect=hsqldb

# unitils will construct the test database using the ddl file found in this
# directory
dbMaintainer.fileScriptSource.scripts.location=src/main/resources

updateDataBaseSchema.enabled=true
sequenceUpdater.sequencevalue.lowestacceptable=100

dataSetStructureGenerator.xsd.dirName=src/test/resources/dataset-schema
#dbMaintainer.autoCreateExecutedScriptsTable property to true 

© Programmers or respective owner

Related posts about java